{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "import os,ogr\n",
    "path = os.getcwd()+\"/shp/\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "import gdal\n",
    "gdal.SetConfigOption(\"GDAL_FILENAME_IS_UTF8\", \"YES\")\n",
    "gdal.SetConfigOption(\"SHAPE_ENCODING\", \"CP936\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "pnt = path + \"北京_point.shp\"\n",
    "driver = ogr.GetDriverByName('ESRI Shapefile')\n",
    "dataSource = driver.Open(pnt, 0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "layer = dataSource.GetLayerByIndex(0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "lyd = layer.GetLayerDefn()\n",
    "fields = [lyd.GetFieldDefn(i).GetName() for i in range(lyd.GetFieldCount())]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['NAME',\n",
       " 'LAYER',\n",
       " 'MARINE',\n",
       " 'RegionName',\n",
       " 'DataLevel',\n",
       " 'MP_TYPE',\n",
       " 'Phone',\n",
       " 'StreetDesc',\n",
       " 'HighwayIdx',\n",
       " 'ZipIdx',\n",
       " 'City']"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fields"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "wkt = \"POLYGON((116.300784 40.005689,\\\n",
    "                116.331398 40.005523,\\\n",
    "                116.333698 39.986619,\\\n",
    "                116.304808 39.987559,\\\n",
    "                116.300784 40.005689))\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "sf = ogr.CreateGeometryFromWkt(wkt)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "POLYGON ((116.300784 40.005689,116.331398 40.005523,116.333698 39.986619,116.304808 39.987559,116.300784 40.005689))\n"
     ]
    }
   ],
   "source": [
    "print(sf)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "教参外语书店\n",
      "民生银行ATM\n",
      "北京银行ATM\n",
      "北京银行ATM\n",
      "清华大学热能动力仿真与控制研究所\n",
      "清青咖啡厅\n",
      "清青面吧\n",
      "水木文泉图书有限公司\n",
      "清华大学印刷厂\n",
      "清华文源科技有限公司\n",
      "清大金地科技有限公司\n",
      "清华大学出版社\n",
      "学服新明眼镜\n",
      "中国体视学学会\n",
      "清华大学治安派出所\n",
      "停车场\n",
      "停车场\n",
      "停车场\n",
      "建行ATM\n",
      "北京核电厂培训中心\n",
      "菲迪克-清华大学-中咨协会培训中心\n",
      "紫荆学生超市\n",
      "清华大学游泳馆\n",
      "保龄球练习馆\n",
      "清华大学乒乓球馆\n",
      "结构工程研究所\n",
      "清华大学电力电子工程研究中心\n",
      "清华大学教育研究所\n",
      "动力机械与工程研究所\n",
      "清华大学公共安全研究中心\n",
      "清华大学天然再生资源工程研究中心\n",
      "清华元丰汽车电控技术研究所\n",
      "汽车研究所\n",
      "机械工程与材料工艺研究所\n",
      "清华汽车工程开发研究院\n",
      "清华大学公共安全研究中心\n",
      "工程物理系安全科学与技术研究所\n",
      "微电子学研究所\n",
      "建设工程信息技术研究中心\n",
      "国际工程项目管理研究院\n",
      "清华大学校史展览馆\n",
      "清青快餐厅\n",
      "北京市清华园胶印厂\n",
      "真维斯五道口销售分店\n",
      "停车场\n",
      "北京城市学院培训中心暂安处教学区\n",
      "五道口购物中心\n",
      "北京华联五道口店\n",
      "蜀圣楼\n",
      "嘉和一品粥五道口店\n",
      "优盛大厦\n",
      "海淀区政府东升地区办事处\n",
      "海淀区东升乡政府\n",
      "海淀区东升法庭\n",
      "清华园美容美发保健中心\n",
      "凤仪轩\n",
      "西海岸洗浴中心\n",
      "贵和堂\n",
      "光合作用书房水木店\n",
      "视界龙平价眼镜超市中关村店\n",
      "亮视点华清嘉园店\n",
      "宝岛眼镜成府路店\n",
      "中国联通手机专卖\n",
      "中国移动五道口手机广场\n",
      "迪信通手机连锁成府路店\n",
      "素人海店\n",
      "红英五道口店\n",
      "鸿星尔克\n",
      "风之羽翼唯因男装\n",
      "U-NEED海淀华清店\n",
      "森马五道口店\n",
      "罗宾汉五道口店\n",
      "天瑞炫服饰\n",
      "柏瑞.诗顿五道口店\n",
      "美特斯 邦威五道口分店\n",
      "华伦天奴新派服饰成府路店\n",
      "安踏体育\n",
      "金凤成祥华清嘉园店\n",
      "华清嘉园\n",
      "学院路街道西王庄社区\n",
      "东升园公寓\n",
      "华清嘉园北门\n",
      "北京城建第四医院\n",
      "北京吕氏口腔门诊\n",
      "学院路街道城建四社区卫生站\n",
      "恒瑞口腔\n",
      "北京心怿康中医门诊部\n",
      "中国康辉旅行社公司\n",
      "神舟国旅集团五道口门市部\n",
      "停车场\n",
      "停车场\n",
      "停车场\n",
      "学研大厦停车场\n",
      "停车场\n",
      "停车场\n",
      "东升园公寓停车场\n",
      "五道口华清嘉园前停车场\n",
      "停车场\n",
      "停车场\n",
      "停车场\n",
      "停车场\n",
      "东升汇银停车场\n",
      "清华同方大厦停车场\n",
      "五道口轻轨站B出入口南口\n",
      "五道口轻轨站A出入口北口\n",
      "建行ATM\n",
      "建行成府路储蓄所\n",
      "光大银行ATM\n",
      "北京银行清华园支行\n",
      "北京银行ATM\n",
      "北京农村商业银行五道口分理处\n",
      "北京农村商业银行ATM\n",
      "华清嘉园邮电所\n",
      "长城润化油汽车养护中心\n",
      "达世行快修\n",
      "首汽租赁中关村经营部\n",
      "海淀区东升法律服务所\n",
      "东升乡文明市民学校中心校\n",
      "华清达力美术培训中心\n",
      "东升文化教育培训学校\n",
      "公厕\n",
      "公厕\n",
      "711便利店华清嘉园店\n",
      "华润万家生活超市成府路店\n",
      "今时联超市\n",
      "青鸟健身中关村店\n",
      "东恒台球城清华园店\n",
      "和子休闲健身\n",
      "快乐地带KTV\n",
      "中华高丽学院\n",
      "明天幼稚园集团第五幼儿园分园\n",
      "启明双语幼儿园\n",
      "材料科学与工程研究院\n",
      "中关村第二小学\n",
      "中国人民银行研究生部\n",
      "地球村语言学校\n",
      "亚洲开发银行北京资料馆\n",
      "清华园宾馆\n",
      "清华园宾馆贵宾楼\n",
      "和家宾馆北四环店\n",
      "赤诚旅馆\n",
      "华清园招待所\n",
      "阳光咖啡\n",
      "来音客咖啡厅\n",
      "卡瓦小镇咖啡馆\n",
      "SPR COFFEE\n",
      "悠游时光休闲茶舍\n",
      "盒子咖啡馆\n",
      "味汁茶餐厅\n",
      "成都小吃清东甜美快餐厅\n",
      "比比客五道口店\n",
      "双马餐厅\n",
      "必胜客五道口餐厅\n",
      "李先生美国加州牛肉面大王五道口店\n",
      "肯德基五道口店\n",
      "仙踪林华清嘉园店\n",
      "赛百味华清嘉园店\n",
      "东北老乡\n",
      "鼎逸火锅坊\n",
      "博悦铭双福园东北农家菜\n",
      "蓉娇林饭庄\n",
      "苏轼酒楼\n",
      "嘉和一品粥东源店\n",
      "希珍面吧五道口店\n",
      "金桔韩式火锅\n",
      "TAFI意大利餐厅\n",
      "秘传\n",
      "多乐之日五道口店\n",
      "鱼太郎\n",
      "玛噶家2\n",
      "香猪坊韩国料理\n",
      "比格华清店\n",
      "海淀区东升农工商总公司\n",
      "清华大学出版社\n",
      "学研大厦\n",
      "北美软件工程有限公司\n",
      "海升集团\n",
      "同方大厦\n",
      "清华大学音像出版社\n",
      "北京东升供销实业总公司\n",
      "中国铁通清华支局\n",
      "东源大厦\n",
      "城建第四医院\n",
      "五道口轻轨站\n",
      "东升乡政府\n",
      "华业大厦停车场\n",
      "停车场\n",
      "停车场\n",
      "停车场\n",
      "停车场\n",
      "停车场\n",
      "建行ATM\n",
      "建行清华园支行\n",
      "招商银行清华园支行\n",
      "招商银行ATM\n",
      "紫光超市\n",
      "清华大学\n",
      "清华大学信息技术研究院\n",
      "清华大学建筑节能研究中心\n",
      "清华大学微电子学研究所\n",
      "清华大学核能与新能源技术研究院\n",
      "清华大学核能技术设计研究院\n",
      "紫光国际交流中心\n",
      "小滋煨汤\n",
      "宴铭园餐厅\n",
      "华业大厦\n",
      "紫光大厦\n",
      "东升大厦C座\n",
      "科技大厦A\n",
      "华业大厦\n",
      "海淀区清华园街道办\n",
      "敬老公寓\n",
      "清华图片社\n",
      "清华图片社\n",
      "黄山图片社\n",
      "学明眼镜\n",
      "海淀区清华园地区消协\n",
      "清华大学老科学技术工作者协会\n",
      "停车场\n",
      "停车场\n",
      "停车场\n",
      "停车场\n",
      "中行清华园支行\n",
      "北京银行清华大学支行\n",
      "北京银行ATM\n",
      "建行清华大学支行\n",
      "建行ATM\n",
      "清华大学邮电支局邮政储蓄\n",
      "工行清华大学储蓄所\n",
      "清华大学邮电支局\n",
      "清华大学继续教育学院司法培训中心\n",
      "清华大学继续教育学院语言文化培训中心\n",
      "清华大学专利事务所\n",
      "公厕\n",
      "北京同仁堂清华园药店\n",
      "清华澜园百货商店\n",
      "清华澜园超市\n",
      "北京华澜园集贸市场中心\n",
      "清华大学洁华幼儿园\n",
      "清华大学材料系能源环境材料研究所\n",
      "清华大学21世纪发展研究院\n",
      "清华大学南门\n",
      "上岛咖啡创业大厦店\n",
      "喜乐仕贵州餐厅\n",
      "全面具到创业大厦店\n",
      "粤华园酒楼\n",
      "清华大学设备仪器厂\n",
      "清华大学通力公司\n",
      "清华大学科教仪器厂\n",
      "华迪合成材料公司\n",
      "清华文泉技术开发公司\n",
      "清华大学出版社\n",
      "中国网通清华园营业厅\n",
      "清华科技园 创业大厦\n",
      "创新大厦\n",
      "立业大厦\n",
      "清华正大商贸公司\n",
      "新林院\n",
      "海淀区中关村工商所\n",
      "易拍数码影像服务中心\n",
      "阳光丽影\n",
      "爱丝美场\n",
      "朋克美发美容\n",
      "风亦情美容养生馆\n",
      "审美美容美发城成府路店\n",
      "华清良子健身中心\n",
      "亚汇利中医美容蓝旗店\n",
      "亮视点清华大学店\n",
      "阿目眼镜\n",
      "大场面眼镜直通车五道口店\n",
      "格林娜眼镜连锁企业清华园店\n",
      "骏朗眼镜蓝旗营店\n",
      "中国联通手机专卖星球通蓝旗营营业厅\n",
      "万祥云尚服饰成府路蓝旗营店\n",
      "骆驼品牌户外休闲\n",
      "黛英蓝旗营店\n",
      "李宁\n",
      "成尔酒行\n",
      "京烟超市保福寺店\n",
      "金凤成祥成府路店\n",
      "AMIGO\n",
      "福奈特华清嘉园店\n",
      "清华科技园国际会议中心\n",
      "启迪国际会议中心\n",
      "蓝旗营小区\n",
      "蓝旗营小区东门\n",
      "水清木华园小区\n",
      "燕归园\n",
      "济安堂中医门诊部\n",
      "停车场\n",
      "停车场\n",
      "停车场\n",
      "停车场\n",
      "兰旗营教师住宅区停车场\n",
      "五道口蓝润大厦前停车场\n",
      "停车场\n",
      "中关村北二条燕归园停车场\n",
      "停车场\n",
      "五道口成府路麦当劳前停车场\n",
      "中信银行清华园支行\n",
      "中信银行ATM\n",
      "北京农村商业银行成府分理处\n",
      "北京农村商业银行ATM\n",
      "工行清华园支行\n",
      "工行ATM\n",
      "工行ATM\n",
      "工行成府路分理处\n",
      "德意志银行ATM\n",
      "德意志银行科技大厦支行\n",
      "光大银行ATM\n",
      "北京银行ATM\n",
      "中信银行ATM\n",
      "农行成府路分理处\n",
      "农行ATM\n",
      "京铁清华园加油站\n",
      "公厕\n",
      "华尔街英语\n",
      "公厕\n",
      "天鹰语言中心\n",
      "公厕\n",
      "公厕\n",
      "海淀供电东升社区电力服务所\n",
      "新东方水清木华校区\n",
      "同德堂药店\n",
      "济安堂药店\n",
      "超市发蓝润店\n",
      "易初莲花购物中心成府路店\n",
      "屈臣氏五道口店\n",
      "首航超市蓝旗营店\n",
      "浩沙健身清华俱乐部\n",
      "13CLUB\n",
      "D-22\n",
      "中国科学院过程工程研究所西区西院\n",
      "生化工程国家重点实验室\n",
      "中科院过程工程研究所\n",
      "北京市清华园兴起中学\n",
      "北京大学化学与分子工程学院应用化学系应用化学研究所\n",
      "中国社会科学院台湾研究所\n",
      "科峰公寓\n",
      "北京未名国际青年旅舍\n",
      "文津国际酒店\n",
      "客座公寓\n",
      "科电招待所\n",
      "百宜源商务会馆\n",
      "国韵风茶楼\n",
      "STARBUCKS COFFEE清华科技园店\n",
      "爱吧 05\n",
      "SPR COFFEE水木清华店\n",
      "来吧咖啡屋\n",
      "上岛咖啡成府路店\n",
      "避风塘茶楼成府路店\n",
      "酷浪咖啡\n",
      "兄弟波罗斯咖啡\n",
      "飨客茶餐厅\n",
      "盛世莲花\n",
      "品奇比萨中关村东路店\n",
      "麦当劳华清餐厅\n",
      "老家肉饼五道口店\n",
      "永和大王成府路店\n",
      "田野家清华园店\n",
      "国强拉面甘肃餐厅\n",
      "阳坊大都涮羊肉清华园店\n",
      "景晨轩美食成府路店\n",
      "尚村精品私家菜\n",
      "千锅居\n",
      "精品台湾菜\n",
      "水木锦堂\n",
      "嘉和一品粥清华店\n",
      "西域胡杨\n",
      "红辣子\n",
      "麻辣香锅妮妮娅餐厅\n",
      "烤全鱼\n",
      "贵州三绝\n",
      "今蜀鲶鱼庄\n",
      "心雨屋小馆\n",
      "大家福火锅\n",
      "五方院精品湘菜\n",
      "满盆香水煮鱼\n",
      "串门\n",
      "川福楼重庆火锅城\n",
      "京丽缘川菜\n",
      "醉爱时尚餐厅\n",
      "梦雅轩餐厅\n",
      "品诺意式餐厅五道口店\n",
      "有乐和食日式面馆\n",
      "全聚德清华园店\n",
      "后院书房意大利餐厅\n",
      "元绿一品料理五道口店\n",
      "三才堂写字楼\n",
      "北京大学技物楼\n",
      "科技大厦B\n",
      "搜狐\n",
      "搜狐网络大厦\n",
      "谷歌\n",
      "科建大厦\n",
      "科技大厦D\n",
      "MICROSOFT\n",
      "威盛大厦\n",
      "科技大厦C\n",
      "蓝润大厦\n",
      "华清商务会馆\n",
      "首创证券五道口证券服务部\n",
      "广发证券中关村东路营业部\n",
      "东升大厦\n",
      "搜狐网络大厦\n",
      "燕归园\n",
      "蓝润大厦\n",
      "清华大学热能工程系动力机械与工程研究所\n",
      "生物力学与医学工程研究所\n",
      "北京国环清华环境工程设计研究院\n",
      "河流海洋研究所\n",
      "水利工程系泥沙研究室\n",
      "清华园\n",
      "清华大学图书馆\n",
      "清华大学广播台\n",
      "中国网通清华营业厅\n",
      "近春园养颜美容中心\n",
      "新华书店清华店\n",
      "亮的眼镜\n",
      "中国学位与研究生教育学会\n",
      "停车场\n",
      "停车场\n",
      "工行清华大学分理处\n",
      "工行ATM\n",
      "清华西区集贸市场\n",
      "建筑环境与设备研究所\n",
      "热能工程与热物理研究所\n",
      "清华大学热能工程研究所\n",
      "煤清洁燃烧国家工程研究中心\n",
      "清华大学科研院\n",
      "熙春园餐厅\n",
      "中国移动清华园营业厅\n",
      "清华大学学生文化活动中心\n",
      "停车场\n",
      "清华大学艺术教育中心\n",
      "清华大学体育与健康科学研究中心\n",
      "高分子研究所\n",
      "生命科学与工程研究所\n",
      "清华大学海洋科学与工程研究中心\n",
      "清华-中鲁海洋生物技术研究所\n",
      "万圣书园\n",
      "清华大学老年活动中心\n",
      "北京星光世纪旅行社\n",
      "停车场\n",
      "停车场\n",
      "停车场\n",
      "停车场\n",
      "停车场\n",
      "交行中关村支行\n",
      "交行ATM\n",
      "北大青鸟\n",
      "公厕\n",
      "北京蓝旗星台球俱乐部\n",
      "北京大学遥感与地理信息系统研究所\n",
      "北京大学数字中国研究院\n",
      "北京大学重离子物理研究所\n",
      "北大附小东门\n",
      "北京大学幼儿园\n",
      "北京大学工学院\n",
      "北京大学微电子学研究院\n",
      "清华大学西南门\n",
      "北京大学物理学院\n",
      "北京大学东侧门\n",
      "清华大学附属小学\n",
      "精英社\n",
      "羊大爷涮肉清华南路店\n",
      "竹鱼坊总店\n",
      "北京大学印刷厂\n",
      "北京大学出版社\n",
      "北京大学音像出版社\n",
      "廖凯原楼\n",
      "北大物理学院\n",
      "清华大学\n",
      "大明眼镜第四十店\n",
      "中国化学会\n",
      "北京大学中关园\n",
      "北京大学教育基金会\n",
      "北京大学学生科协\n",
      "燕园派出所\n",
      "燕园金秋口腔\n",
      "停车场\n",
      "停车场\n",
      "停车场\n",
      "民生银行成府路支行\n",
      "民生银行ATM\n",
      "北京银行ATM\n",
      "北京银行北京大学支行\n",
      "农行ATM\n",
      "中铁快运北京海淀营业部\n",
      "公厕\n",
      "公厕\n",
      "第一体育馆\n",
      "北京大学体育馆\n",
      "中科院化学研究所\n",
      "北京大学中国教育与人力资源研究中心\n",
      "高等教育科学研究所\n",
      "北京大学企业与教育研究中心\n",
      "北京大学东门\n",
      "北京大学中国古文献研究中心\n",
      "北京大学化学应用开发研究所\n",
      "北京大学化学与分子工程学院\n",
      "北京大学-富士通信息科学技术联合研究中心\n",
      "北京大学香港中文大学智能工程联合研究中心\n",
      "北京大学TCL信息技术研究中心\n",
      "北京大学微电子学研究院\n",
      "北京大学言语听觉研究中心\n",
      "中国哲学暨文化研究所\n",
      "北京大学东南门\n",
      "北京大学中国地震局现代地震科学技术研究中心\n",
      "北京大学石油与天然气研究中心\n",
      "北京大学中国持续发展研究中心\n",
      "北京大学经济法研究所\n",
      "北京大学外国哲学研究所\n",
      "北京大学教育经济研究所\n",
      "北京大学政治发展与政府管理研究所\n",
      "北京现代物理研究中心\n",
      "北京大学高能物理研究中心\n",
      "北京大学汉语语言学研究中心\n",
      "北京大学邓小平理论研究中心\n",
      "北京大学图书馆\n",
      "常安福宾馆\n",
      "鄱阳湖\n",
      "海平烧烤屋\n",
      "北京方正数码有限公司\n",
      "方正世纪信息系统公司\n",
      "北京大学北大德力科技公司\n",
      "方正集团\n",
      "方正大厦\n",
      "北京大学北大德力科化学公司\n",
      "北京中科科仪技术发展有限公司\n",
      "北京中科科仪技术发展公司\n",
      "未名湖\n",
      "中关园\n",
      "燕园\n",
      "游人码头\n",
      "恒通货运\n",
      "华茂汽修\n",
      "漆艺美术高考培训中心\n",
      "仙人承露\n",
      "清华大学西北门\n",
      "清华大学生命科学与医学研究院\n",
      "清华-裕元医学研究中心\n",
      "浩然亭\n",
      "凤麟洲\n",
      "李文连医学与生命科学图书馆\n",
      "清大海归科技发展公司\n",
      "北京华茂科技有限公司\n",
      "曙光科技园\n",
      "乡情乡理容休闲\n",
      "缘叶青美容美发\n",
      "清华急救站\n",
      "清华大学医院\n",
      "清华园社区卫生中心\n",
      "停车场\n",
      "停车场\n",
      "公厕\n",
      "公厕\n",
      "公厕\n",
      "公厕\n",
      "北京双信仁大药房\n",
      "清华大学西门\n",
      "清华大学艾滋病综合研究中心\n",
      "展诗应律\n",
      "单孔桥\n",
      "涵秋馆\n",
      "盛祥农家院\n",
      "天心水画\n",
      "彭氏西门鸡翅烧烤店\n",
      "重庆特色小吃\n",
      "水木西门鸡翅店\n",
      "十二木卡姆新疆美食村清华分店\n",
      "老蜀人川菜馆清华西门分店\n",
      "撒拉尔人家\n",
      "北大科技园\n",
      "直隶会馆\n",
      "恩普公司\n",
      "海淀区汇苑农工商公司\n",
      "清华大学医学院\n",
      "清史书店\n",
      "海淀区青少年活动中心\n",
      "圆明园派出所\n",
      "停车场\n",
      "清华汽修\n",
      "清华开拓加油站NO.438\n",
      "公厕\n",
      "公厕\n",
      "景客隆超市第18分店\n",
      "圆明园遗址公园\n",
      "迎晖门\n",
      "鉴碧亭\n",
      "湘山竹海酒楼\n",
      "白玉清园烤肉\n",
      "毛家湘菜馆\n",
      "水磨坊涮肉\n",
      "兰州老马家拉面\n",
      "芝士城堡\n",
      "中国人保总公司\n",
      "中国人民财产保险机动车保险代办处\n",
      "北京大学四一七公寓\n",
      "公厕\n",
      "公厕\n",
      "北大附小\n",
      "燕园丰禄羊蝎子火锅\n",
      "阿健火锅\n",
      "西门鸡翅烧烤店\n",
      "炭中火\n",
      "北大留学人员创业园\n",
      "北大工学院\n",
      "三夫户外\n",
      "停车场\n",
      "停车场\n",
      "公厕\n",
      "市化工研究院\n",
      "梦旅人咖啡馆\n",
      "大益御膳房\n",
      "华腾科技大厦\n",
      "北京华腾工程新材料公司\n",
      "公厕\n",
      "公厕\n",
      "北京大学中国经济研究中心\n",
      "北京大学中国古代史研究中心\n",
      "未名餐厅\n",
      "苹香榭\n",
      "公厕\n",
      "石舫遗迹\n",
      "别有洞天\n",
      "京卫大药房第九京卫大药房\n",
      "中科院电工研究所\n",
      "中科院北京建筑设计研究院\n",
      "科电大厦\n",
      "朝发夕丝宜人天禧足道按摩健身中心五道口店\n",
      "DAISY\n",
      "REGGIO\n",
      "赛百味财智大厦店\n",
      "黄记煌三汁焖锅财智国际大厦店\n",
      "全面具到财智国际大厦店\n",
      "和发源食府\n",
      "新陆峰洲京味菜馆\n",
      "咖啡时间西餐厅财智大厦店\n",
      "清华园\n",
      "燕园\n"
     ]
    }
   ],
   "source": [
    "layer.SetSpatialFilter(sf)\n",
    "feDict = []\n",
    "for feature in layer:\n",
    "    name = feature.GetField(\"NAME\")\n",
    "    print(\"{0}\".format(name))\n",
    "    f = {}\n",
    "    for field in fields:\n",
    "        f[field] = feature.GetField(field)\n",
    "    geo = feature.GetGeometryRef()\n",
    "    f[\"Shape\"] = geo.ExportToWkt()\n",
    "    feDict.append(f)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>City</th>\n",
       "      <th>DataLevel</th>\n",
       "      <th>HighwayIdx</th>\n",
       "      <th>LAYER</th>\n",
       "      <th>MARINE</th>\n",
       "      <th>MP_TYPE</th>\n",
       "      <th>NAME</th>\n",
       "      <th>Phone</th>\n",
       "      <th>RegionName</th>\n",
       "      <th>Shape</th>\n",
       "      <th>StreetDesc</th>\n",
       "      <th>ZipIdx</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2E0A</td>\n",
       "      <td>教参外语书店</td>\n",
       "      <td>01062771967</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.32044 40.005 0)</td>\n",
       "      <td>清华大学十食堂二层</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Bank</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2F06</td>\n",
       "      <td>民生银行ATM</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.31752 40.00544 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Bank</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2F06</td>\n",
       "      <td>北京银行ATM</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.32109 40.00508 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Bank</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2F06</td>\n",
       "      <td>北京银行ATM</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.31804 40.00548 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>清华大学热能动力仿真与控制研究所</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.32819 40.00499 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2A0E</td>\n",
       "      <td>清青咖啡厅</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.31612 40.00531 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2A04</td>\n",
       "      <td>清青面吧</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.32044 40.005 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2900</td>\n",
       "      <td>水木文泉图书有限公司</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.32819 40.00499 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2900</td>\n",
       "      <td>清华大学印刷厂</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.32827 40.00443 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2900</td>\n",
       "      <td>清华文源科技有限公司</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.32819 40.00499 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2900</td>\n",
       "      <td>清大金地科技有限公司</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.32819 40.00499 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2900</td>\n",
       "      <td>清华大学出版社</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.32819 40.00499 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2F10</td>\n",
       "      <td>学服新明眼镜</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.32236 40.00315 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x3005</td>\n",
       "      <td>中国体视学学会</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.32703 40.00147 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x3001</td>\n",
       "      <td>清华大学治安派出所</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.32147 40.00041 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2F0B</td>\n",
       "      <td>停车场</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.3269 40.00079 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2F0B</td>\n",
       "      <td>停车场</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.3284 40.00074 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2F0B</td>\n",
       "      <td>停车场</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.32922 39.99988 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Bank</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2F06</td>\n",
       "      <td>建行ATM</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.32159 40.00517 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2F00</td>\n",
       "      <td>北京核电厂培训中心</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.32451 39.99955 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2F00</td>\n",
       "      <td>菲迪克-清华大学-中咨协会培训中心</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.32391 40.00217 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2E02</td>\n",
       "      <td>紫荆学生超市</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.32236 40.0035 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2D0A</td>\n",
       "      <td>清华大学游泳馆</td>\n",
       "      <td>01062792477</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.32545 40.00555 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2D0A</td>\n",
       "      <td>保龄球练习馆</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.32404 40.00431 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2D0A</td>\n",
       "      <td>清华大学乒乓球馆</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.32228 40.00315 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>结构工程研究所</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.32416 40.00251 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>清华大学电力电子工程研究中心</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.32532 39.99997 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>清华大学教育研究所</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.32147 40.00058 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>动力机械与工程研究所</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.32156 40.00006 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>清华大学公共安全研究中心</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.32703 40.00147 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>611</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2F00</td>\n",
       "      <td>公厕</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.30858 39.99842 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>612</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>市化工研究院</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.30815 39.99774 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>613</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2A0E</td>\n",
       "      <td>梦旅人咖啡馆</td>\n",
       "      <td>01082613756</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.30618 39.99812 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>614</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2A04</td>\n",
       "      <td>大益御膳房</td>\n",
       "      <td>01086023333</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.30781 39.99795 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>615</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2900</td>\n",
       "      <td>华腾科技大厦</td>\n",
       "      <td>01062650549</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.30815 39.99774 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>616</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2900</td>\n",
       "      <td>北京华腾工程新材料公司</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.30815 39.99774 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>617</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2F00</td>\n",
       "      <td>公厕</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.30614 39.99756 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>618</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2F00</td>\n",
       "      <td>公厕</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.30395 39.99584 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>619</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京大学中国经济研究中心</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.3037 39.99641 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>620</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京大学中国古代史研究中心</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.30349 39.99667 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>621</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2A04</td>\n",
       "      <td>未名餐厅</td>\n",
       "      <td>01062547689</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.30614 39.99782 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>622</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Landmark</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C04</td>\n",
       "      <td>苹香榭</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.3028 40.00156 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>623</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2F00</td>\n",
       "      <td>公厕</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.30276 40.0056 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>624</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Landmark</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C04</td>\n",
       "      <td>石舫遗迹</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.3013 40.0053 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>625</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Landmark</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C04</td>\n",
       "      <td>别有洞天</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.30242 40.00568 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>626</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2E05</td>\n",
       "      <td>京卫大药房第九京卫大药房</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.3153 39.98742 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>627</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>中科院电工研究所</td>\n",
       "      <td>01062542031</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.32113 39.98757 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>628</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>中科院北京建筑设计研究院</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.31569 39.98737 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>629</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2900</td>\n",
       "      <td>科电大厦</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.32061 39.98736 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>630</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2F10</td>\n",
       "      <td>朝发夕丝宜人天禧足道按摩健身中心五道口店</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.33132 39.9873 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>631</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2D02</td>\n",
       "      <td>DAISY</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.33132 39.98747 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>632</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2D02</td>\n",
       "      <td>REGGIO</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.33132 39.98739 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>633</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2A07</td>\n",
       "      <td>赛百味财智大厦店</td>\n",
       "      <td>01082600900</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.32772 39.98692 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>634</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2A04</td>\n",
       "      <td>黄记煌三汁焖锅财智国际大厦店</td>\n",
       "      <td>01082600800</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.32742 39.98688 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>635</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2A04</td>\n",
       "      <td>全面具到财智国际大厦店</td>\n",
       "      <td>01082600524</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.3278 39.98692 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>636</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2A04</td>\n",
       "      <td>和发源食府</td>\n",
       "      <td>01086204163</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.33135 39.98691 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>637</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2A04</td>\n",
       "      <td>新陆峰洲京味菜馆</td>\n",
       "      <td>01062570033</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.33135 39.98721 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>638</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2A00</td>\n",
       "      <td>咖啡时间西餐厅财智大厦店</td>\n",
       "      <td>01085467026</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.32763 39.98692 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>639</th>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>City, &lt; 10K</td>\n",
       "      <td>N</td>\n",
       "      <td>0x0C00</td>\n",
       "      <td>清华园</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.32023 40.00324 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>640</th>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>City, &lt; 10K</td>\n",
       "      <td>N</td>\n",
       "      <td>0x0C00</td>\n",
       "      <td>燕园</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.30627 39.99259 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>641 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     City  DataLevel HighwayIdx                  LAYER MARINE MP_TYPE  \\\n",
       "0    None          1       None  Unknown Point Feature      N  0x2E0A   \n",
       "1    None          1       None                   Bank      N  0x2F06   \n",
       "2    None          1       None                   Bank      N  0x2F06   \n",
       "3    None          1       None                   Bank      N  0x2F06   \n",
       "4    None          1       None                 School      N  0x2C05   \n",
       "5    None          1       None  Unknown Point Feature      N  0x2A0E   \n",
       "6    None          1       None  Unknown Point Feature      N  0x2A04   \n",
       "7    None          1       None  Unknown Point Feature      N  0x2900   \n",
       "8    None          1       None  Unknown Point Feature      N  0x2900   \n",
       "9    None          1       None  Unknown Point Feature      N  0x2900   \n",
       "10   None          1       None  Unknown Point Feature      N  0x2900   \n",
       "11   None          1       None  Unknown Point Feature      N  0x2900   \n",
       "12   None          1       None  Unknown Point Feature      N  0x2F10   \n",
       "13   None          1       None  Unknown Point Feature      N  0x3005   \n",
       "14   None          1       None  Unknown Point Feature      N  0x3001   \n",
       "15   None          1       None  Unknown Point Feature      N  0x2F0B   \n",
       "16   None          1       None  Unknown Point Feature      N  0x2F0B   \n",
       "17   None          1       None  Unknown Point Feature      N  0x2F0B   \n",
       "18   None          1       None                   Bank      N  0x2F06   \n",
       "19   None          1       None  Unknown Point Feature      N  0x2F00   \n",
       "20   None          1       None  Unknown Point Feature      N  0x2F00   \n",
       "21   None          1       None  Unknown Point Feature      N  0x2E02   \n",
       "22   None          1       None  Unknown Point Feature      N  0x2D0A   \n",
       "23   None          1       None  Unknown Point Feature      N  0x2D0A   \n",
       "24   None          1       None  Unknown Point Feature      N  0x2D0A   \n",
       "25   None          1       None                 School      N  0x2C05   \n",
       "26   None          1       None                 School      N  0x2C05   \n",
       "27   None          1       None                 School      N  0x2C05   \n",
       "28   None          1       None                 School      N  0x2C05   \n",
       "29   None          1       None                 School      N  0x2C05   \n",
       "..    ...        ...        ...                    ...    ...     ...   \n",
       "611  None          1       None  Unknown Point Feature      N  0x2F00   \n",
       "612  None          1       None                 School      N  0x2C05   \n",
       "613  None          1       None  Unknown Point Feature      N  0x2A0E   \n",
       "614  None          1       None  Unknown Point Feature      N  0x2A04   \n",
       "615  None          1       None  Unknown Point Feature      N  0x2900   \n",
       "616  None          1       None  Unknown Point Feature      N  0x2900   \n",
       "617  None          1       None  Unknown Point Feature      N  0x2F00   \n",
       "618  None          1       None  Unknown Point Feature      N  0x2F00   \n",
       "619  None          1       None                 School      N  0x2C05   \n",
       "620  None          1       None                 School      N  0x2C05   \n",
       "621  None          1       None  Unknown Point Feature      N  0x2A04   \n",
       "622  None          1       None               Landmark      N  0x2C04   \n",
       "623  None          1       None  Unknown Point Feature      N  0x2F00   \n",
       "624  None          1       None               Landmark      N  0x2C04   \n",
       "625  None          1       None               Landmark      N  0x2C04   \n",
       "626  None          1       None  Unknown Point Feature      N  0x2E05   \n",
       "627  None          1       None                 School      N  0x2C05   \n",
       "628  None          1       None                 School      N  0x2C05   \n",
       "629  None          1       None  Unknown Point Feature      N  0x2900   \n",
       "630  None          1       None  Unknown Point Feature      N  0x2F10   \n",
       "631  None          1       None  Unknown Point Feature      N  0x2D02   \n",
       "632  None          1       None  Unknown Point Feature      N  0x2D02   \n",
       "633  None          1       None  Unknown Point Feature      N  0x2A07   \n",
       "634  None          1       None  Unknown Point Feature      N  0x2A04   \n",
       "635  None          1       None  Unknown Point Feature      N  0x2A04   \n",
       "636  None          1       None  Unknown Point Feature      N  0x2A04   \n",
       "637  None          1       None  Unknown Point Feature      N  0x2A04   \n",
       "638  None          1       None  Unknown Point Feature      N  0x2A00   \n",
       "639     Y          1       None            City, < 10K      N  0x0C00   \n",
       "640     Y          1       None            City, < 10K      N  0x0C00   \n",
       "\n",
       "                     NAME        Phone RegionName  \\\n",
       "0                  教参外语书店  01062771967        北京市   \n",
       "1                 民生银行ATM         None        北京市   \n",
       "2                 北京银行ATM         None        北京市   \n",
       "3                 北京银行ATM         None        北京市   \n",
       "4        清华大学热能动力仿真与控制研究所         None        北京市   \n",
       "5                   清青咖啡厅         None        北京市   \n",
       "6                    清青面吧         None        北京市   \n",
       "7              水木文泉图书有限公司         None        北京市   \n",
       "8                 清华大学印刷厂         None        北京市   \n",
       "9              清华文源科技有限公司         None        北京市   \n",
       "10             清大金地科技有限公司         None        北京市   \n",
       "11                清华大学出版社         None        北京市   \n",
       "12                 学服新明眼镜         None        北京市   \n",
       "13                中国体视学学会         None        北京市   \n",
       "14              清华大学治安派出所         None        北京市   \n",
       "15                    停车场         None        北京市   \n",
       "16                    停车场         None        北京市   \n",
       "17                    停车场         None        北京市   \n",
       "18                  建行ATM         None        北京市   \n",
       "19              北京核电厂培训中心         None        北京市   \n",
       "20      菲迪克-清华大学-中咨协会培训中心         None        北京市   \n",
       "21                 紫荆学生超市         None        北京市   \n",
       "22                清华大学游泳馆  01062792477        北京市   \n",
       "23                 保龄球练习馆         None        北京市   \n",
       "24               清华大学乒乓球馆         None        北京市   \n",
       "25                结构工程研究所         None        北京市   \n",
       "26         清华大学电力电子工程研究中心         None        北京市   \n",
       "27              清华大学教育研究所         None        北京市   \n",
       "28             动力机械与工程研究所         None        北京市   \n",
       "29           清华大学公共安全研究中心         None        北京市   \n",
       "..                    ...          ...        ...   \n",
       "611                    公厕         None        北京市   \n",
       "612                市化工研究院         None        北京市   \n",
       "613                梦旅人咖啡馆  01082613756        北京市   \n",
       "614                 大益御膳房  01086023333        北京市   \n",
       "615                华腾科技大厦  01062650549        北京市   \n",
       "616           北京华腾工程新材料公司         None        北京市   \n",
       "617                    公厕         None        北京市   \n",
       "618                    公厕         None        北京市   \n",
       "619          北京大学中国经济研究中心         None        北京市   \n",
       "620         北京大学中国古代史研究中心         None        北京市   \n",
       "621                  未名餐厅  01062547689        北京市   \n",
       "622                   苹香榭         None        北京市   \n",
       "623                    公厕         None        北京市   \n",
       "624                  石舫遗迹         None        北京市   \n",
       "625                  别有洞天         None        北京市   \n",
       "626          京卫大药房第九京卫大药房         None        北京市   \n",
       "627              中科院电工研究所  01062542031        北京市   \n",
       "628          中科院北京建筑设计研究院         None        北京市   \n",
       "629                  科电大厦         None        北京市   \n",
       "630  朝发夕丝宜人天禧足道按摩健身中心五道口店         None        北京市   \n",
       "631                 DAISY         None        北京市   \n",
       "632                REGGIO         None        北京市   \n",
       "633              赛百味财智大厦店  01082600900        北京市   \n",
       "634        黄记煌三汁焖锅财智国际大厦店  01082600800        北京市   \n",
       "635           全面具到财智国际大厦店  01082600524        北京市   \n",
       "636                 和发源食府  01086204163        北京市   \n",
       "637              新陆峰洲京味菜馆  01062570033        北京市   \n",
       "638          咖啡时间西餐厅财智大厦店  01085467026        北京市   \n",
       "639                   清华园         None        北京市   \n",
       "640                    燕园         None        北京市   \n",
       "\n",
       "                            Shape StreetDesc ZipIdx  \n",
       "0      POINT (116.32044 40.005 0)  清华大学十食堂二层   None  \n",
       "1    POINT (116.31752 40.00544 0)       None   None  \n",
       "2    POINT (116.32109 40.00508 0)       None   None  \n",
       "3    POINT (116.31804 40.00548 0)       None   None  \n",
       "4    POINT (116.32819 40.00499 0)       None   None  \n",
       "5    POINT (116.31612 40.00531 0)       None   None  \n",
       "6      POINT (116.32044 40.005 0)       None   None  \n",
       "7    POINT (116.32819 40.00499 0)       None   None  \n",
       "8    POINT (116.32827 40.00443 0)       None   None  \n",
       "9    POINT (116.32819 40.00499 0)       None   None  \n",
       "10   POINT (116.32819 40.00499 0)       None   None  \n",
       "11   POINT (116.32819 40.00499 0)       None   None  \n",
       "12   POINT (116.32236 40.00315 0)       None   None  \n",
       "13   POINT (116.32703 40.00147 0)       None   None  \n",
       "14   POINT (116.32147 40.00041 0)       None   None  \n",
       "15    POINT (116.3269 40.00079 0)       None   None  \n",
       "16    POINT (116.3284 40.00074 0)       None   None  \n",
       "17   POINT (116.32922 39.99988 0)       None   None  \n",
       "18   POINT (116.32159 40.00517 0)       None   None  \n",
       "19   POINT (116.32451 39.99955 0)       None   None  \n",
       "20   POINT (116.32391 40.00217 0)       None   None  \n",
       "21    POINT (116.32236 40.0035 0)       None   None  \n",
       "22   POINT (116.32545 40.00555 0)       None   None  \n",
       "23   POINT (116.32404 40.00431 0)       None   None  \n",
       "24   POINT (116.32228 40.00315 0)       None   None  \n",
       "25   POINT (116.32416 40.00251 0)       None   None  \n",
       "26   POINT (116.32532 39.99997 0)       None   None  \n",
       "27   POINT (116.32147 40.00058 0)       None   None  \n",
       "28   POINT (116.32156 40.00006 0)       None   None  \n",
       "29   POINT (116.32703 40.00147 0)       None   None  \n",
       "..                            ...        ...    ...  \n",
       "611  POINT (116.30858 39.99842 0)       None   None  \n",
       "612  POINT (116.30815 39.99774 0)       None   None  \n",
       "613  POINT (116.30618 39.99812 0)       None   None  \n",
       "614  POINT (116.30781 39.99795 0)       None   None  \n",
       "615  POINT (116.30815 39.99774 0)       None   None  \n",
       "616  POINT (116.30815 39.99774 0)       None   None  \n",
       "617  POINT (116.30614 39.99756 0)       None   None  \n",
       "618  POINT (116.30395 39.99584 0)       None   None  \n",
       "619   POINT (116.3037 39.99641 0)       None   None  \n",
       "620  POINT (116.30349 39.99667 0)       None   None  \n",
       "621  POINT (116.30614 39.99782 0)       None   None  \n",
       "622   POINT (116.3028 40.00156 0)       None   None  \n",
       "623   POINT (116.30276 40.0056 0)       None   None  \n",
       "624    POINT (116.3013 40.0053 0)       None   None  \n",
       "625  POINT (116.30242 40.00568 0)       None   None  \n",
       "626   POINT (116.3153 39.98742 0)       None   None  \n",
       "627  POINT (116.32113 39.98757 0)       None   None  \n",
       "628  POINT (116.31569 39.98737 0)       None   None  \n",
       "629  POINT (116.32061 39.98736 0)       None   None  \n",
       "630   POINT (116.33132 39.9873 0)       None   None  \n",
       "631  POINT (116.33132 39.98747 0)       None   None  \n",
       "632  POINT (116.33132 39.98739 0)       None   None  \n",
       "633  POINT (116.32772 39.98692 0)       None   None  \n",
       "634  POINT (116.32742 39.98688 0)       None   None  \n",
       "635   POINT (116.3278 39.98692 0)       None   None  \n",
       "636  POINT (116.33135 39.98691 0)       None   None  \n",
       "637  POINT (116.33135 39.98721 0)       None   None  \n",
       "638  POINT (116.32763 39.98692 0)       None   None  \n",
       "639  POINT (116.32023 40.00324 0)       None   None  \n",
       "640  POINT (116.30627 39.99259 0)       None   None  \n",
       "\n",
       "[641 rows x 12 columns]"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sfpd = pd.DataFrame(feDict)\n",
    "sfpd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>City</th>\n",
       "      <th>DataLevel</th>\n",
       "      <th>HighwayIdx</th>\n",
       "      <th>LAYER</th>\n",
       "      <th>MARINE</th>\n",
       "      <th>MP_TYPE</th>\n",
       "      <th>NAME</th>\n",
       "      <th>Phone</th>\n",
       "      <th>RegionName</th>\n",
       "      <th>Shape</th>\n",
       "      <th>StreetDesc</th>\n",
       "      <th>ZipIdx</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>336</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京大学化学与分子工程学院应用化学系应用化学研究所</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.32066 39.98878 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>389</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2900</td>\n",
       "      <td>北京大学技物楼</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.31993 39.98832 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>453</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京大学遥感与地理信息系统研究所</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.30622 39.99181 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>454</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京大学数字中国研究院</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.30622 39.99181 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>455</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京大学重离子物理研究所</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.31372 39.99124 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>457</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京大学幼儿园</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.31389 39.99438 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>458</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京大学工学院</td>\n",
       "      <td>01062751812</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.31218 39.99266 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>459</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京大学微电子学研究院</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.31033 39.99189 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>461</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京大学物理学院</td>\n",
       "      <td>01062751732</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.31033 39.99103 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>462</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京大学东侧门</td>\n",
       "      <td>01062752114</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.30721 39.9916 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>467</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2900</td>\n",
       "      <td>北京大学印刷厂</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.31329 39.99124 0)</td>\n",
       "      <td>成府路203</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>468</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2900</td>\n",
       "      <td>北京大学出版社</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.31244 39.9912 0)</td>\n",
       "      <td>成府路205</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>469</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2900</td>\n",
       "      <td>北京大学音像出版社</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.31244 39.9912 0)</td>\n",
       "      <td>成府路205</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>475</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x3005</td>\n",
       "      <td>北京大学中关园</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.31226 39.99064 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>476</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x3005</td>\n",
       "      <td>北京大学教育基金会</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.30434 39.99533 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>477</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x3005</td>\n",
       "      <td>北京大学学生科协</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.30567 39.99117 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>486</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Bank</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2F06</td>\n",
       "      <td>北京银行北京大学支行</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.31016 39.99017 0)</td>\n",
       "      <td>成府路298临时</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>492</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2D0A</td>\n",
       "      <td>北京大学体育馆</td>\n",
       "      <td>01062753697</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.30948 39.98808 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>494</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京大学中国教育与人力资源研究中心</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.30554 39.98842 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>496</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京大学企业与教育研究中心</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.30554 39.98842 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>497</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京大学东门</td>\n",
       "      <td>01062752114</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.30922 39.99078 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京大学中国古文献研究中心</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.30442 39.98962 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京大学化学应用开发研究所</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.31064 39.98983 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京大学化学与分子工程学院</td>\n",
       "      <td>01062751710</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.31068 39.99056 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>501</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京大学-富士通信息科学技术联合研究中心</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.3088 39.98898 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>502</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京大学香港中文大学智能工程联合研究中心</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.3088 39.98898 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>503</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京大学TCL信息技术研究中心</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.3088 39.98898 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>504</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京大学微电子学研究院</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.3088 39.98898 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>505</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京大学言语听觉研究中心</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.3088 39.98898 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>507</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京大学东南门</td>\n",
       "      <td>01062752114</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.30943 39.98881 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>508</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京大学中国地震局现代地震科学技术研究中心</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.30876 39.99057 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>509</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京大学石油与天然气研究中心</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.30876 39.99057 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>510</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京大学中国持续发展研究中心</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.30571 39.99031 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>511</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京大学经济法研究所</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.30571 39.99005 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>512</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京大学外国哲学研究所</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.30571 39.99005 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>513</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京大学教育经济研究所</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.30571 39.99005 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>514</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京大学政治发展与政府管理研究所</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.30571 39.99005 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>516</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京大学高能物理研究中心</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.30601 39.99009 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>517</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京大学汉语语言学研究中心</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.30571 39.99005 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>518</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京大学邓小平理论研究中心</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.30571 39.99005 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>519</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Library</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C03</td>\n",
       "      <td>北京大学图书馆</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.30442 39.99057 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>525</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2900</td>\n",
       "      <td>北京大学北大德力科技公司</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.31064 39.98983 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>528</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2900</td>\n",
       "      <td>北京大学北大德力科化学公司</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.31064 39.98983 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>598</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>Unknown Point Feature</td>\n",
       "      <td>N</td>\n",
       "      <td>0x3005</td>\n",
       "      <td>北京大学四一七公寓</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.31201 39.99618 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>619</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京大学中国经济研究中心</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.3037 39.99641 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>620</th>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>School</td>\n",
       "      <td>N</td>\n",
       "      <td>0x2C05</td>\n",
       "      <td>北京大学中国古代史研究中心</td>\n",
       "      <td>None</td>\n",
       "      <td>北京市</td>\n",
       "      <td>POINT (116.30349 39.99667 0)</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     City  DataLevel HighwayIdx                  LAYER MARINE MP_TYPE  \\\n",
       "336  None          1       None                 School      N  0x2C05   \n",
       "389  None          1       None  Unknown Point Feature      N  0x2900   \n",
       "453  None          1       None                 School      N  0x2C05   \n",
       "454  None          1       None                 School      N  0x2C05   \n",
       "455  None          1       None                 School      N  0x2C05   \n",
       "457  None          1       None                 School      N  0x2C05   \n",
       "458  None          1       None                 School      N  0x2C05   \n",
       "459  None          1       None                 School      N  0x2C05   \n",
       "461  None          1       None                 School      N  0x2C05   \n",
       "462  None          1       None                 School      N  0x2C05   \n",
       "467  None          1       None  Unknown Point Feature      N  0x2900   \n",
       "468  None          1       None  Unknown Point Feature      N  0x2900   \n",
       "469  None          1       None  Unknown Point Feature      N  0x2900   \n",
       "475  None          1       None  Unknown Point Feature      N  0x3005   \n",
       "476  None          1       None  Unknown Point Feature      N  0x3005   \n",
       "477  None          1       None  Unknown Point Feature      N  0x3005   \n",
       "486  None          1       None                   Bank      N  0x2F06   \n",
       "492  None          1       None  Unknown Point Feature      N  0x2D0A   \n",
       "494  None          1       None                 School      N  0x2C05   \n",
       "496  None          1       None                 School      N  0x2C05   \n",
       "497  None          1       None                 School      N  0x2C05   \n",
       "498  None          1       None                 School      N  0x2C05   \n",
       "499  None          1       None                 School      N  0x2C05   \n",
       "500  None          1       None                 School      N  0x2C05   \n",
       "501  None          1       None                 School      N  0x2C05   \n",
       "502  None          1       None                 School      N  0x2C05   \n",
       "503  None          1       None                 School      N  0x2C05   \n",
       "504  None          1       None                 School      N  0x2C05   \n",
       "505  None          1       None                 School      N  0x2C05   \n",
       "507  None          1       None                 School      N  0x2C05   \n",
       "508  None          1       None                 School      N  0x2C05   \n",
       "509  None          1       None                 School      N  0x2C05   \n",
       "510  None          1       None                 School      N  0x2C05   \n",
       "511  None          1       None                 School      N  0x2C05   \n",
       "512  None          1       None                 School      N  0x2C05   \n",
       "513  None          1       None                 School      N  0x2C05   \n",
       "514  None          1       None                 School      N  0x2C05   \n",
       "516  None          1       None                 School      N  0x2C05   \n",
       "517  None          1       None                 School      N  0x2C05   \n",
       "518  None          1       None                 School      N  0x2C05   \n",
       "519  None          1       None                Library      N  0x2C03   \n",
       "525  None          1       None  Unknown Point Feature      N  0x2900   \n",
       "528  None          1       None  Unknown Point Feature      N  0x2900   \n",
       "598  None          1       None  Unknown Point Feature      N  0x3005   \n",
       "619  None          1       None                 School      N  0x2C05   \n",
       "620  None          1       None                 School      N  0x2C05   \n",
       "\n",
       "                          NAME        Phone RegionName  \\\n",
       "336  北京大学化学与分子工程学院应用化学系应用化学研究所         None        北京市   \n",
       "389                    北京大学技物楼         None        北京市   \n",
       "453           北京大学遥感与地理信息系统研究所         None        北京市   \n",
       "454                北京大学数字中国研究院         None        北京市   \n",
       "455               北京大学重离子物理研究所         None        北京市   \n",
       "457                    北京大学幼儿园         None        北京市   \n",
       "458                    北京大学工学院  01062751812        北京市   \n",
       "459                北京大学微电子学研究院         None        北京市   \n",
       "461                   北京大学物理学院  01062751732        北京市   \n",
       "462                    北京大学东侧门  01062752114        北京市   \n",
       "467                    北京大学印刷厂         None        北京市   \n",
       "468                    北京大学出版社         None        北京市   \n",
       "469                  北京大学音像出版社         None        北京市   \n",
       "475                    北京大学中关园         None        北京市   \n",
       "476                  北京大学教育基金会         None        北京市   \n",
       "477                   北京大学学生科协         None        北京市   \n",
       "486                 北京银行北京大学支行         None        北京市   \n",
       "492                    北京大学体育馆  01062753697        北京市   \n",
       "494          北京大学中国教育与人力资源研究中心         None        北京市   \n",
       "496              北京大学企业与教育研究中心         None        北京市   \n",
       "497                     北京大学东门  01062752114        北京市   \n",
       "498              北京大学中国古文献研究中心         None        北京市   \n",
       "499              北京大学化学应用开发研究所         None        北京市   \n",
       "500              北京大学化学与分子工程学院  01062751710        北京市   \n",
       "501       北京大学-富士通信息科学技术联合研究中心         None        北京市   \n",
       "502       北京大学香港中文大学智能工程联合研究中心         None        北京市   \n",
       "503            北京大学TCL信息技术研究中心         None        北京市   \n",
       "504                北京大学微电子学研究院         None        北京市   \n",
       "505               北京大学言语听觉研究中心         None        北京市   \n",
       "507                    北京大学东南门  01062752114        北京市   \n",
       "508      北京大学中国地震局现代地震科学技术研究中心         None        北京市   \n",
       "509             北京大学石油与天然气研究中心         None        北京市   \n",
       "510             北京大学中国持续发展研究中心         None        北京市   \n",
       "511                 北京大学经济法研究所         None        北京市   \n",
       "512                北京大学外国哲学研究所         None        北京市   \n",
       "513                北京大学教育经济研究所         None        北京市   \n",
       "514           北京大学政治发展与政府管理研究所         None        北京市   \n",
       "516               北京大学高能物理研究中心         None        北京市   \n",
       "517              北京大学汉语语言学研究中心         None        北京市   \n",
       "518              北京大学邓小平理论研究中心         None        北京市   \n",
       "519                    北京大学图书馆         None        北京市   \n",
       "525               北京大学北大德力科技公司         None        北京市   \n",
       "528              北京大学北大德力科化学公司         None        北京市   \n",
       "598                  北京大学四一七公寓         None        北京市   \n",
       "619               北京大学中国经济研究中心         None        北京市   \n",
       "620              北京大学中国古代史研究中心         None        北京市   \n",
       "\n",
       "                            Shape StreetDesc ZipIdx  \n",
       "336  POINT (116.32066 39.98878 0)       None   None  \n",
       "389  POINT (116.31993 39.98832 0)       None   None  \n",
       "453  POINT (116.30622 39.99181 0)       None   None  \n",
       "454  POINT (116.30622 39.99181 0)       None   None  \n",
       "455  POINT (116.31372 39.99124 0)       None   None  \n",
       "457  POINT (116.31389 39.99438 0)       None   None  \n",
       "458  POINT (116.31218 39.99266 0)       None   None  \n",
       "459  POINT (116.31033 39.99189 0)       None   None  \n",
       "461  POINT (116.31033 39.99103 0)       None   None  \n",
       "462   POINT (116.30721 39.9916 0)       None   None  \n",
       "467  POINT (116.31329 39.99124 0)     成府路203   None  \n",
       "468   POINT (116.31244 39.9912 0)     成府路205   None  \n",
       "469   POINT (116.31244 39.9912 0)     成府路205   None  \n",
       "475  POINT (116.31226 39.99064 0)       None   None  \n",
       "476  POINT (116.30434 39.99533 0)       None   None  \n",
       "477  POINT (116.30567 39.99117 0)       None   None  \n",
       "486  POINT (116.31016 39.99017 0)   成府路298临时   None  \n",
       "492  POINT (116.30948 39.98808 0)       None   None  \n",
       "494  POINT (116.30554 39.98842 0)       None   None  \n",
       "496  POINT (116.30554 39.98842 0)       None   None  \n",
       "497  POINT (116.30922 39.99078 0)       None   None  \n",
       "498  POINT (116.30442 39.98962 0)       None   None  \n",
       "499  POINT (116.31064 39.98983 0)       None   None  \n",
       "500  POINT (116.31068 39.99056 0)       None   None  \n",
       "501   POINT (116.3088 39.98898 0)       None   None  \n",
       "502   POINT (116.3088 39.98898 0)       None   None  \n",
       "503   POINT (116.3088 39.98898 0)       None   None  \n",
       "504   POINT (116.3088 39.98898 0)       None   None  \n",
       "505   POINT (116.3088 39.98898 0)       None   None  \n",
       "507  POINT (116.30943 39.98881 0)       None   None  \n",
       "508  POINT (116.30876 39.99057 0)       None   None  \n",
       "509  POINT (116.30876 39.99057 0)       None   None  \n",
       "510  POINT (116.30571 39.99031 0)       None   None  \n",
       "511  POINT (116.30571 39.99005 0)       None   None  \n",
       "512  POINT (116.30571 39.99005 0)       None   None  \n",
       "513  POINT (116.30571 39.99005 0)       None   None  \n",
       "514  POINT (116.30571 39.99005 0)       None   None  \n",
       "516  POINT (116.30601 39.99009 0)       None   None  \n",
       "517  POINT (116.30571 39.99005 0)       None   None  \n",
       "518  POINT (116.30571 39.99005 0)       None   None  \n",
       "519  POINT (116.30442 39.99057 0)       None   None  \n",
       "525  POINT (116.31064 39.98983 0)       None   None  \n",
       "528  POINT (116.31064 39.98983 0)       None   None  \n",
       "598  POINT (116.31201 39.99618 0)       None   None  \n",
       "619   POINT (116.3037 39.99641 0)       None   None  \n",
       "620  POINT (116.30349 39.99667 0)       None   None  "
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bj = sfpd[sfpd[\"NAME\"].str.contains(r'北京大学*')]\n",
    "bj"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "46"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(bj)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
